﻿

-- 录像机配置获取
create procedure [dbo].[DVRSet_Get]
@MyKey varchar(50) = null,
@Type bit = null
as
select Mykey,MyValue,[Type] from DVR_Set where  
(@MyKey is null or MyKey=@MyKey) and (@Type is null or [type]=@Type)